# -*- coding: utf-8 -*-

# Define here the models for your scraped items
#
# See documentation in:
# https://docs.scrapy.org/en/latest/topics/items.html

import scrapy


class CaifuItem(scrapy.Item):
    # define the fields for your item here like:
    bb = scrapy.Field()
    INDUSTRY = scrapy.Field()
    COMPAE = scrapy.Field()
    PERATIO = scrapy.Field()

    def get_sql(self):
        sql = 'insert into zhanglong2(id,daima,gongshi,shiyinglv,zhonglei)VALUES(null,%s,%s,%s,%s)'
        data=[self['bb'],self['COMPAE'],self['PERATIO'],self['INDUSTRY']]
        return sql ,data